package com.fushenlan.epidemicControl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fushenlan.po.NeighborhoodMemberDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface NeighborhoodMemberMapper extends BaseMapper<NeighborhoodMemberDO> {
    List<Map<String, Object>> listAllById(@Param("id") Long id);

    @Select({"select id,memberName,jobName,neighborhoodId,account,inhabitantId,memberPhone from neighborhood_member where memberPhone = #{phoneNumber}"})
    Map<String, Object> selectMember(@Param("phoneNumber") String phoneNumber);
}